IF NOT EXISTS(SELECT [Name] FROM syscolumns WHERE Name = 'IsDeleted' AND ID = OBJECT_ID('dbo.Producer')) BEGIN
   ALTER TABLE Producer ADD IsDeleted BIT CONSTRAINT [rdf_Producer_IsDeleted] DEFAULT (0)
   EXEC ('UPDATE Producer SET IsDeleted = 0')
END

IF NOT EXISTS(SELECT [Name] FROM syscolumns WHERE Name = 'IsDeleted' AND ID = OBJECT_ID('dbo.ProductType')) BEGIN
   ALTER TABLE ProductType ADD IsDeleted BIT CONSTRAINT [rdf_ProductType_IsDeleted] DEFAULT (0)
   EXEC ('UPDATE ProductType SET IsDeleted = 0')
END

